package com.empire.module.spider.dal.mysql.lotteryfootballgamezucaibqc;

import java.util.*;

import com.empire.framework.common.pojo.PageResult;
import com.empire.framework.mybatis.core.query.LambdaQueryWrapperX;
import com.empire.framework.mybatis.core.mapper.BaseMapperX;
import com.empire.module.spider.dal.dataobject.lotteryfootballgamezucaibqc.LotteryFootballGameZucaiBqcDO;
import org.apache.ibatis.annotations.Mapper;
import com.empire.module.spider.controller.app.lotteryfootballgamezucaibqc.vo.*;

/**
 * 足彩6场半全场游戏 Mapper
 *
 * @author 无敌
 */
@Mapper
public interface LotteryFootballGameZucaiBqcMapper extends BaseMapperX<LotteryFootballGameZucaiBqcDO> {

    default PageResult<LotteryFootballGameZucaiBqcDO> selectPage(AppLotteryFootballGameZucaiBqcPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<LotteryFootballGameZucaiBqcDO>()
                .eqIfPresent(LotteryFootballGameZucaiBqcDO::getGameNo, reqVO.getGameNo())
                .betweenIfPresent(LotteryFootballGameZucaiBqcDO::getStopTime, reqVO.getStopTime())
                .eqIfPresent(LotteryFootballGameZucaiBqcDO::getResult, reqVO.getResult())
                .eqIfPresent(LotteryFootballGameZucaiBqcDO::getExpect, reqVO.getExpect())
                .betweenIfPresent(LotteryFootballGameZucaiBqcDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(LotteryFootballGameZucaiBqcDO::getFid));
    }

}
